USE [influenza]
GO

/****** Object:  StoredProcedure [dbo].[SP_cmbProcedimiento]    Script Date: 01/03/2010 10:28:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[SP_cmbProcedimiento]
@param varchar(10)
as
Begin
declare @qry VARCHAR(8000)
SET @qry='Select id_proc, procedimiento from cat_lab_proc Where activo=1'
exec (@qry)	
END

GO

